UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qJjnbMKk0fwufFVrMF7CXuz3j0KOUr3DQWWubNr4HJk='
WHERE
key_id = 'a1e2f3b550cc016f0ba0f2bf3c2d27a97e3471adcae1b30e6b094dc22b41e658'
AND (
token = 'qJjnbMKk0fwufFVrMF7CXuz3j0KOUr3DQWWubNr4HJk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)