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