UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hYUY0Lt3XfM2iHTBEIW+2uRz2AeDYYRXso1HJ8zhYgE='
WHERE
key_id = 'ae80d175f36dcd993df60d24a490e3a6ab4562e1d3abe99111da661c4736ceaf'
AND (
token = 'hYUY0Lt3XfM2iHTBEIW+2uRz2AeDYYRXso1HJ8zhYgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)