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