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