UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qY2VZwC2CvAHV9Vok+EEKu9dKjAtr49kMPEEO9FBOkw='
WHERE
key_id = 'd16fd70f3e6fb5dcdcce69c23b147eee9af4a1ea79e998a684324dba079edf85'
AND (
token = 'qY2VZwC2CvAHV9Vok+EEKu9dKjAtr49kMPEEO9FBOkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)