UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nA1H292r6xK3i9MRC1ml0JfNIigReTkh8QhqZU45jvA='
WHERE
key_id = '0c88789ce6dc0d471d99e3e89de122d56833f72a75b830208a06f5b23456475a'
AND (
token = 'nA1H292r6xK3i9MRC1ml0JfNIigReTkh8QhqZU45jvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)