UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UXpxHHMC5PL1nZ1zn71NuJgvkUb3XjueSjyf76z/dho='
WHERE
key_id = 'a87ed3dfb0055fa6a3dc6bbb2627f6ccd237e4b6921c7377e99937881ac7e4f4'
AND (
token = 'UXpxHHMC5PL1nZ1zn71NuJgvkUb3XjueSjyf76z/dho='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)