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