UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GZg3MTytk1TimIk65lWWpXAYzLfkO3DGtQO41KlqhV0='
WHERE
key_id = '7b7b6187bed3394db59627bf4979707173f2f865a14ba82af90b157dac4705a9'
AND (
token = 'GZg3MTytk1TimIk65lWWpXAYzLfkO3DGtQO41KlqhV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)