UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BjE2XXKtc5wzdK8lTo5lYrh4m3RCHMtFRFnViUeeY08='
WHERE
key_id = '865368bd1d0234908a63b0eb865a45ab49de197fc0930e6c406f7f00d8b54374'
AND (
token = 'BjE2XXKtc5wzdK8lTo5lYrh4m3RCHMtFRFnViUeeY08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)