UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S5qgSETTFT2kSCQYCrPoA7PA2jFbTKVWXWpnunLcRws='
WHERE
key_id = 'bea964295370b96a09fa25e41e4670eb86834bc09ae763e26e795d5f5abe2050'
AND (
token = 'S5qgSETTFT2kSCQYCrPoA7PA2jFbTKVWXWpnunLcRws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)