UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z7tJO8JTByzoCZpa6jkroujVCxHV8s9G26nh+gLsr7s='
WHERE
key_id = '11a1741c28a5a1224258f356c91d16beb0a27ec4cae0b3670eb8c1671aacd010'
AND (
token = 'z7tJO8JTByzoCZpa6jkroujVCxHV8s9G26nh+gLsr7s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)