UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q9ajo/dXLm2ErQtLQCORXIo8ADYDCP1iVxjC3E3HD5Q='
WHERE
key_id = '6282153bb1aaac3cf2027a1475392fe3058d8a0300a5855316f867d6943f8800'
AND (
token = 'q9ajo/dXLm2ErQtLQCORXIo8ADYDCP1iVxjC3E3HD5Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)