UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'd+zSILiV9F+qFfV6DcpEc8W/+/8UXNpGjUIW5yb+TwY=' 
WHERE 
  key_id = '527ec40feca66b734594e560eb1a8113445d606ed2e7730f7621e4e8b2f56b2a' 
  AND (
    token = 'd+zSILiV9F+qFfV6DcpEc8W/+/8UXNpGjUIW5yb+TwY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021