UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aPDBdI1wlQHNjH3OMT2VHMWWMQrKu+mzeQuV+85rdIg='
WHERE
key_id = 'a297712ef482863c5c565ef5666375f850d178e59a8530f72102545b2a3bbdcb'
AND (
token = 'aPDBdI1wlQHNjH3OMT2VHMWWMQrKu+mzeQuV+85rdIg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)