UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iOFgIQCQyLTG9kVPCQ+5imGbETT8PNUBzbWrtHJAnm4='
WHERE
key_id = '0ef2458c585b2511bee6187695700ccab0eaab997ffc03a8bc234f567b6f1036'
AND (
token = 'iOFgIQCQyLTG9kVPCQ+5imGbETT8PNUBzbWrtHJAnm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)