UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZqHAzkmnV489wexI43hYzhPxdyNBkM4cnZei6MO+xII='
WHERE
key_id = 'e52b28b824992d00a61630ab124048bec7ea06859b32ae79b2f8dcff4e9d09f9'
AND (
token = 'ZqHAzkmnV489wexI43hYzhPxdyNBkM4cnZei6MO+xII='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)