UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6zXrcfAfxOPFDlAZdf+0gDD1/4/dAOZI0vBHHc6AAS4='
WHERE
key_id = 'aedff4de341df66d985ec450de2c6030f7fb159d47c7305a11b5c475ffc32490'
AND (
token = '6zXrcfAfxOPFDlAZdf+0gDD1/4/dAOZI0vBHHc6AAS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)