UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mPL8VbDROgqhqxYXmH0hiN5SfKZ9HCLMXne77cWRCSU='
WHERE
key_id = '46b04f08f68e8bccd68228c5886a0fefbfb442d56946162d00674b1e90b818a7'
AND (
token = 'mPL8VbDROgqhqxYXmH0hiN5SfKZ9HCLMXne77cWRCSU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)