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