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