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