UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x1dpd6hI1o+TR4HnB6NvZDXmZcHPJYatFgFzgPGhoy8='
WHERE
key_id = 'ec3a7fee03c7e07102d59d893bd9bccf77a5c774e421d12ed983017750caedcc'
AND (
token = 'x1dpd6hI1o+TR4HnB6NvZDXmZcHPJYatFgFzgPGhoy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)