UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BR4MjEnPQmic6PQy3i1J8QxLpLkiguHl1/5cFdRFgxo='
WHERE
key_id = 'a512a23969adc6cc357fd12464830e8652cd10a630b183065cc4d9058dc4e414'
AND (
token = 'BR4MjEnPQmic6PQy3i1J8QxLpLkiguHl1/5cFdRFgxo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)