UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pvj0M1gMd5jbo9O+2iCrpYBC9hZLZafhT0HYkwSl50Y='
WHERE
key_id = '3cc8956a319e237a9b0522d3be3bd54a3fcf909b9ba1fd8f9fd8d41a7fe59dfb'
AND (
token = 'pvj0M1gMd5jbo9O+2iCrpYBC9hZLZafhT0HYkwSl50Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)