UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gX/ae1gGAwZhTdhYE6QdSjsU1FTLflbvLZak6kqBiZE='
WHERE
key_id = '2e1b5918dbb166ec99d3e9e87dd66bbdd2802f8a1dc448d655fd72e9fa9af795'
AND (
token = 'gX/ae1gGAwZhTdhYE6QdSjsU1FTLflbvLZak6kqBiZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)