UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JpfE85zEDqy7HU8+EbsOh1CQX9KwgYOwwybGA0GK1Kg='
WHERE
key_id = 'def5597d21c5c6697ca1dd7d24ac6b4506e92757c444fac34d25a81069b63639'
AND (
token = 'JpfE85zEDqy7HU8+EbsOh1CQX9KwgYOwwybGA0GK1Kg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)