UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l7NhwizrjRVOtsdEb0+QKVn7rzyZXFNlC4Sd7D9PhJs='
WHERE
key_id = '23ffe22788515e7134c86c5403b27594569c95f226bddb7ed584ca99a30b0220'
AND (
token = 'l7NhwizrjRVOtsdEb0+QKVn7rzyZXFNlC4Sd7D9PhJs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)